/*
	Created: Jonathan Turner
		On : 10/18/2013
Description: Get all roles and their descriptions
	Updates:
*/
ALTER PROCEDURE dbo.GetAllRoles
  @LoweredApplicationName VARCHAR(100)
AS 
  SELECT  rol.RoleName
        , rol.RoleId
        , rol.Description
  FROM    dbo.aspnet_Roles AS rol
  INNER JOIN dbo.aspnet_Applications AS app ON rol.ApplicationId = app.ApplicationId
  WHERE   app.LoweredApplicationName = @LoweredApplicationName
GO